PostgreSQL 对象管理 查看数据库大小

SELECT schemaname,tablename,sys_size_pretty(sys_relation_size(schemaname || '.' || tablename )) as size_p,
sys_total_relation_size(schemaname || '.' || tablename) as siz,
sys_size_pretty(sys_total_relation_size(schemaname || '.' || tablename)) as total_size_p ,
sys_total_relation_size (schemaname || '.'  || tablename ) - sys_relation_size(schemaname || '.' || tablename) as index_size ,
(100 * ( sys_total_relation_size (schemaname || '.' || tablename ) - sys_relation_size (schemaname || '.' || tablename )))/CASE (name || '.' || tablename) = 0 THEN 1 ELSE sys_total_relation_size(schemaname || '.' || tablename) END || '%' AS index_pct 
from pg_tables 
ORDER BY siz DESC LINIT 10;

```�